<?php return array (
  0 => 'CREATE TABLE `xiaozu_order` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `dno` varchar(100) NOT NULL COMMENT \'订单编号\',
  `shopuid` int(20) NOT NULL COMMENT \'店铺UID\',
  `shopid` int(20) NOT NULL COMMENT \'店铺ID\',
  `shopname` varchar(100) NOT NULL COMMENT \'店铺名称\',
  `shopphone` varchar(20) NOT NULL COMMENT \'店铺电话\',
  `shopaddress` varchar(150) NOT NULL COMMENT \'店铺地址\',
  `buyeruid` int(20) NOT NULL COMMENT \'购买用户ID，0未注册用户\',
  `buyername` varchar(100) NOT NULL COMMENT \'购买热名称\',
  `buyeraddress` varchar(150) NOT NULL COMMENT \'联系地址\',
  `buyerphone` varchar(20) NOT NULL COMMENT \'联系电话\',
  `status` int(1) NOT NULL COMMENT \'状态\',
  `is_acceptorder` int(1) NOT NULL DEFAULT \'0\' COMMENT \'确认收货 0 未确认 1已确认\',
  `paytype` varchar(20) NOT NULL DEFAULT \'0\' COMMENT \'支付类型outpay货到支付，open_acout账户余额支付，other调用paylist\',
  `paystatus` int(1) NOT NULL COMMENT \'支付状态1已支付\',
  `trade_no` varchar(50) NOT NULL COMMENT \'在线支付交易号\',
  `content` varchar(255) NOT NULL COMMENT \'订单备注\',
  `ordertype` int(1) NOT NULL DEFAULT \'0\' COMMENT \'订餐方式1网站，2电话，3微信，4App\',
  `daycode` int(10) NOT NULL DEFAULT \'0\' COMMENT \'当天订单序号\',
  `area1` varchar(255) DEFAULT NULL COMMENT \'二级地址名称\',
  `area2` varchar(255) DEFAULT NULL COMMENT \'三级地址名称\',
  `area3` varchar(255) DEFAULT NULL,
  `cxids` varchar(100) DEFAULT NULL COMMENT \'促销规则ID集\',
  `cxcost` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'店铺促销优惠金额\',
  `yhjcost` int(5) NOT NULL DEFAULT \'0\' COMMENT \'优惠劵优惠金额\',
  `yhjids` varchar(255) DEFAULT NULL COMMENT \'使用优惠劵ID集\',
  `ipaddress` varchar(255) DEFAULT NULL,
  `scoredown` int(5) NOT NULL DEFAULT \'0\' COMMENT \'积分抵扣数\',
  `is_ping` int(11) NOT NULL DEFAULT \'0\' COMMENT \'是否评价字段 1已评完 0未评\',
  `isbefore` int(1) NOT NULL DEFAULT \'0\' COMMENT \'0:普通订单，1订台订单\',
  `marketcost` decimal(6,2) NOT NULL DEFAULT \'0.00\' COMMENT \'超市商品总价\',
  `marketps` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'超市配送配送\',
  `shopcost` decimal(6,2) NOT NULL DEFAULT \'0.00\' COMMENT \'店铺商品总价\',
  `shopps` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'店铺配送费\',
  `pstype` int(1) NOT NULL DEFAULT \'0\' COMMENT \'配送方式 0：平台1：个人\',
  `bagcost` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'打包费\',
  `addtime` int(12) NOT NULL DEFAULT \'0\' COMMENT \'制造时间\',
  `posttime` int(12) NOT NULL DEFAULT \'0\' COMMENT \'配送时间\',
  `passtime` int(12) NOT NULL DEFAULT \'0\' COMMENT \'审核时间\',
  `sendtime` int(12) NOT NULL DEFAULT \'0\' COMMENT \'发货时间\',
  `suretime` int(12) NOT NULL DEFAULT \'0\' COMMENT \'完成时间\',
  `allcost` decimal(6,2) NOT NULL DEFAULT \'0.00\' COMMENT \'订单实收费\',
  `buycode` varchar(50) DEFAULT NULL COMMENT \'订台码\',
  `othertext` text COMMENT \'其他说明\',
  `is_print` int(1) NOT NULL DEFAULT \'0\',
  `wxstatus` int(1) NOT NULL DEFAULT \'0\' COMMENT \'1商家确认，2商家取消\',
  `shoptype` int(1) DEFAULT \'0\',
  `is_make` int(1) NOT NULL DEFAULT \'0\',
  `is_reback` smallint(1) DEFAULT \'0\',
  `areaids` char(255) DEFAULT NULL,
  `psuid` int(20) DEFAULT NULL,
  `psusername` varchar(100) DEFAULT NULL,
  `psemail` varchar(100) DEFAULT NULL,
  `admin_id` int(20) NOT NULL DEFAULT \'0\',
  `is_goshop` int(1) NOT NULL DEFAULT \'0\' COMMENT \'0:外送 1订台/到店消费/自取\',
  `paytype_name` varchar(30) DEFAULT NULL COMMENT \'支付类型code\',
  `taxcost` decimal(5,2) NOT NULL,
  `postdate` text,
  `pttype` int(1) NOT NULL COMMENT \'1为帮我送  2为帮我买\',
  `ptkg` varchar(30) NOT NULL COMMENT \'货 公斤 数\',
  `ptkm` varchar(30) NOT NULL COMMENT \'收取货 地址 两地 距离 km\',
  `allkgcost` decimal(10,2) NOT NULL COMMENT \'重量价格\',
  `allkmcost` decimal(10,2) NOT NULL COMMENT \'距离价格\',
  `farecost` decimal(10,2) DEFAULT NULL COMMENT \'小费价格\',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8',
  1 => 'INSERT INTO `xiaozu_order`(`id`,`dno`,`shopuid`,`shopid`,`shopname`,`shopphone`,`shopaddress`,`buyeruid`,`buyername`,`buyeraddress`,`buyerphone`,`status`,`is_acceptorder`,`paytype`,`paystatus`,`trade_no`,`content`,`ordertype`,`daycode`,`area1`,`area2`,`area3`,`cxids`,`cxcost`,`yhjcost`,`yhjids`,`ipaddress`,`scoredown`,`is_ping`,`isbefore`,`marketcost`,`marketps`,`shopcost`,`shopps`,`pstype`,`bagcost`,`addtime`,`posttime`,`passtime`,`sendtime`,`suretime`,`allcost`,`buycode`,`othertext`,`is_print`,`wxstatus`,`shoptype`,`is_make`,`is_reback`,`areaids`,`psuid`,`psusername`,`psemail`,`admin_id`,`is_goshop`,`paytype_name`,`taxcost`,`postdate`,`pttype`,`ptkg`,`ptkm`,`allkgcost`,`allkmcost`,`farecost`) VALUES(\'1\',\'14528495852415\',\'4\',\'4\',\'光合外卖旗舰店\',\'15122211123\',\'棉纺西路4号院1号商业1层商11号\',\'2936\',\'测试\',\'凯旋门\',\'15738832712\',\'3\',\'1\',\'0\',\'0\',\'\',\'\',\'1\',\'1\',\'\',\'\',\'\',\'8\',\'1.00\',\'0\',\'\',\'127.0.0.1本机地址\',\'0\',\'0\',\'0\',\'0.00\',\'0.00\',\'46.00\',\'0.00\',\'0\',\'2.00\',\'1452849585\',\'1452849600\',\'1452849585\',\'1452851124\',\'1452851144\',\'47.00\',\'c970e7\',\'\',\'0\',\'0\',\'0\',\'1\',\'0\',\'\',\'\',\'\',\'\',\'67\',\'0\',\'\',\'0.00\',\'17:20-17:40\',\'0\',\'\',\'\',\'0.00\',\'0.00\',\'\')',
  2 => 'INSERT INTO `xiaozu_order`(`id`,`dno`,`shopuid`,`shopid`,`shopname`,`shopphone`,`shopaddress`,`buyeruid`,`buyername`,`buyeraddress`,`buyerphone`,`status`,`is_acceptorder`,`paytype`,`paystatus`,`trade_no`,`content`,`ordertype`,`daycode`,`area1`,`area2`,`area3`,`cxids`,`cxcost`,`yhjcost`,`yhjids`,`ipaddress`,`scoredown`,`is_ping`,`isbefore`,`marketcost`,`marketps`,`shopcost`,`shopps`,`pstype`,`bagcost`,`addtime`,`posttime`,`passtime`,`sendtime`,`suretime`,`allcost`,`buycode`,`othertext`,`is_print`,`wxstatus`,`shoptype`,`is_make`,`is_reback`,`areaids`,`psuid`,`psusername`,`psemail`,`admin_id`,`is_goshop`,`paytype_name`,`taxcost`,`postdate`,`pttype`,`ptkg`,`ptkm`,`allkgcost`,`allkmcost`,`farecost`) VALUES(\'2\',\'14532782724561\',\'4\',\'4\',\'光合外卖旗舰店\',\'15122211123\',\'棉纺西路4号院1号商业1层商11号\',\'2936\',\'测试\',\'凯旋门\',\'15738832712\',\'3\',\'1\',\'0\',\'0\',\'\',\'\',\'1\',\'1\',\'\',\'\',\'\',\'8\',\'1.00\',\'0\',\'\',\'127.0.0.1本机地址\',\'0\',\'1\',\'0\',\'0.00\',\'0.00\',\'44.00\',\'2.00\',\'0\',\'1.00\',\'1453278272\',\'1453279200\',\'1453278272\',\'1453278279\',\'1453278284\',\'46.00\',\'038f0f\',\'\',\'0\',\'0\',\'0\',\'1\',\'0\',\'\',\'\',\'\',\'\',\'0\',\'0\',\'\',\'0.00\',\'16:40-17:00\',\'0\',\'\',\'\',\'0.00\',\'0.00\',\'\')',
  3 => 'INSERT INTO `xiaozu_order`(`id`,`dno`,`shopuid`,`shopid`,`shopname`,`shopphone`,`shopaddress`,`buyeruid`,`buyername`,`buyeraddress`,`buyerphone`,`status`,`is_acceptorder`,`paytype`,`paystatus`,`trade_no`,`content`,`ordertype`,`daycode`,`area1`,`area2`,`area3`,`cxids`,`cxcost`,`yhjcost`,`yhjids`,`ipaddress`,`scoredown`,`is_ping`,`isbefore`,`marketcost`,`marketps`,`shopcost`,`shopps`,`pstype`,`bagcost`,`addtime`,`posttime`,`passtime`,`sendtime`,`suretime`,`allcost`,`buycode`,`othertext`,`is_print`,`wxstatus`,`shoptype`,`is_make`,`is_reback`,`areaids`,`psuid`,`psusername`,`psemail`,`admin_id`,`is_goshop`,`paytype_name`,`taxcost`,`postdate`,`pttype`,`ptkg`,`ptkm`,`allkgcost`,`allkmcost`,`farecost`) VALUES(\'3\',\'14556202395284\',\'4\',\'4\',\'光合外卖旗舰店\',\'15122211123\',\'棉纺西路4号院1号商业1层商11号\',\'0\',\'dasdas\',\'郑州二七区二七万达dsadas\',\'15738832777\',\'0\',\'0\',\'0\',\'0\',\'\',\'dsadas\',\'7\',\'1\',\'\',\'\',\'\',\'8\',\'1.00\',\'0\',\'\',\'127.0.0.1本机地址\',\'0\',\'0\',\'0\',\'0.00\',\'0.00\',\'30.00\',\'2.00\',\'0\',\'0.00\',\'1455620239\',\'1455620400\',\'1455620239\',\'0\',\'0\',\'31.00\',\'8c8e68\',\'\',\'0\',\'0\',\'0\',\'1\',\'0\',\'116,71,70\',\'\',\'\',\'\',\'0\',\'0\',\'\',\'0.00\',\'19:00-19:20\',\'0\',\'\',\'\',\'0.00\',\'0.00\',\'\')',
  4 => 'INSERT INTO `xiaozu_order`(`id`,`dno`,`shopuid`,`shopid`,`shopname`,`shopphone`,`shopaddress`,`buyeruid`,`buyername`,`buyeraddress`,`buyerphone`,`status`,`is_acceptorder`,`paytype`,`paystatus`,`trade_no`,`content`,`ordertype`,`daycode`,`area1`,`area2`,`area3`,`cxids`,`cxcost`,`yhjcost`,`yhjids`,`ipaddress`,`scoredown`,`is_ping`,`isbefore`,`marketcost`,`marketps`,`shopcost`,`shopps`,`pstype`,`bagcost`,`addtime`,`posttime`,`passtime`,`sendtime`,`suretime`,`allcost`,`buycode`,`othertext`,`is_print`,`wxstatus`,`shoptype`,`is_make`,`is_reback`,`areaids`,`psuid`,`psusername`,`psemail`,`admin_id`,`is_goshop`,`paytype_name`,`taxcost`,`postdate`,`pttype`,`ptkg`,`ptkm`,`allkgcost`,`allkmcost`,`farecost`) VALUES(\'4\',\'14569866439050\',\'4\',\'4\',\'光合外卖旗舰店\',\'15122211123\',\'棉纺西路4号院1号商业1层商11号\',\'0\',\'测试\',\'郑州二七区二七万达aaaaa\',\'15738832712\',\'0\',\'0\',\'0\',\'0\',\'\',\'\',\'7\',\'1\',\'\',\'\',\'\',\'8\',\'1.00\',\'0\',\'\',\'127.0.0.1本机地址\',\'0\',\'0\',\'0\',\'0.00\',\'0.00\',\'226.00\',\'2.00\',\'0\',\'0.00\',\'1456986643\',\'1456987200\',\'1456986643\',\'0\',\'0\',\'227.00\',\'6c5c8b\',\'\',\'0\',\'0\',\'0\',\'1\',\'0\',\'116,71,70\',\'\',\'\',\'\',\'0\',\'0\',\'\',\'0.00\',\'14:40-15:00\',\'0\',\'\',\'\',\'0.00\',\'0.00\',\'\')',
)?>